<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PrestaShop 的数据表 product - v1.6.2</title>
<link rel="stylesheet" href="../css/reset.css" type="text/css" />
<link rel="stylesheet" href="../css/prettify.css" type="text/css" />
<script type="text/javascript" src="../js/prettify.js"></script>
<style type="text/css">
body, table, th, td { color:             #000000; background-color:  #ffffff; font-size:         8pt; }
img { border: 0; }
table, th, td { border-width:      0.1em; border-color:      #000000; border-style:      solid; }
table { border-collapse:   collapse; border-spacing:    0; }
th, td { padding:           0.2em; }
th { font-weight:       bold; background-color:  #e5e5e5; }
</style>
</head>
<body>
<h1>PrestaShop 的 商品信息 - v1.4.6.2</h1>
<hr />
<h3>produc 数据表</h3>
<table>
  <thead>
    <tr>
      <th width="26">编号</th>
      <th width="117">字段</th>
      <th width="136">类型</th>
      <th width="23">Null</th>
      <th width="45">默认</th>
      <th width="65">注释</th>
      <th width="38">MIME</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>1</th>
      <th> id_product </th>
      <td>int(10) </td>
      <td>否&nbsp;</td>
      <td>&nbsp;</td>
      <th>商品ID</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>2</th>
      <th> id_supplier </th>
      <td>int(10) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>供应商ID</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>3</th>
      <th> id_manufacturer </th>
      <td>int(10) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>生产商ID</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>4</th>
      <th> id_tax_rules_group </th>
      <td>int(10) </td>
      <td>否&nbsp;</td>
      <td>&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>5</th>
      <th> id_category_default </th>
      <td>int(10) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>分类ID</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>6</th>
      <th> id_color_default </th>
      <td>int(10) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>7</th>
      <th> on_sale </th>
      <td>tinyint(1) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>8</th>
      <th> online_only </th>
      <td>tinyint(1) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>只在线销售</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>9</th>
      <th> ean13 </th>
      <td>varchar(13) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>EAN13条码</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>10</th>
      <th> upc </th>
      <td>varchar(12) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>UPC</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>11</th>
      <th> ecotax </th>
      <td>decimal(17,6) </td>
      <td>否&nbsp;</td>
      <td>0.000000&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>12</th>
      <th> quantity </th>
      <td>int(10) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>13</th>
      <th> minimal_quantity </th>
      <td>int(10) </td>
      <td>否&nbsp;</td>
      <td>1&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>14</th>
      <th> price </th>
      <td>decimal(20,6) </td>
      <td>否&nbsp;</td>
      <td>0.000000&nbsp;</td>
      <th>税前零售价</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>15</th>
      <th> wholesale_price </th>
      <td>decimal(20,6) </td>
      <td>否&nbsp;</td>
      <td>0.000000&nbsp;</td>
      <th>税前批发价</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>16</th>
      <th> unity </th>
      <td>varchar(255) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>17</th>
      <th> unit_price_ratio </th>
      <td>decimal(20,6) </td>
      <td>否&nbsp;</td>
      <td>0.000000&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>18</th>
      <th> additional_shipping_cost </th>
      <td>decimal(20,2) </td>
      <td>否&nbsp;</td>
      <td>0.00&nbsp;</td>
      <th>附加运费</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>19</th>
      <th> reference </th>
      <td>varchar(32) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>参考</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>20</th>
      <th> supplier_reference </th>
      <td>varchar(32) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>供应商参考</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>21</th>
      <th> location </th>
      <td>varchar(64) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>地点（仓库）</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>22</th>
      <th> width </th>
      <td>float </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>宽度</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>23</th>
      <th> height </th>
      <td>float </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>高度</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>24</th>
      <th> depth </th>
      <td>float </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>深度</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>25</th>
      <th> weight </th>
      <td>float </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>重量</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>26</th>
      <th> out_of_stock </th>
      <td>int(10) </td>
      <td>否&nbsp;</td>
      <td>2&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>27</th>
      <th> quantity_discount </th>
      <td>tinyint(1) </td>
      <td>是&nbsp;</td>
      <td>0&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>28</th>
      <th> customizable </th>
      <td>tinyint(2) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>29</th>
      <th> uploadable_files </th>
      <td>tinyint(4) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>30</th>
      <th> text_fields </th>
      <td>tinyint(4) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>31</th>
      <th> active </th>
      <td>tinyint(1) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>是否启用</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>32</th>
      <th> available_for_order </th>
      <td>tinyint(1) </td>
      <td>否&nbsp;</td>
      <td>1&nbsp;</td>
      <th>可否订购</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>33</th>
      <th> condition </th>
      <td>enum('new', 'used', 'refurbished') </td>
      <td>否&nbsp;</td>
      <td>new&nbsp;</td>
      <th>条件（全新、二手、翻新）</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>34</th>
      <th> show_price </th>
      <td>tinyint(1) </td>
      <td>否&nbsp;</td>
      <td>1&nbsp;</td>
      <th>显示价格</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>35</th>
      <th> indexed </th>
      <td>tinyint(1) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>36</th>
      <th> cache_is_pack </th>
      <td>tinyint(1) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>&nbsp;</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>37</th>
      <th> cache_has_attachments </th>
      <td>tinyint(1) </td>
      <td>否&nbsp;</td>
      <td>0&nbsp;</td>
      <th>缓存附件</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>38</th>
      <th> cache_default_attribute </th>
      <td>int(10) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>缓存默认属性</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>39</th>
      <th> date_add </th>
      <td>datetime </td>
      <td>否&nbsp;</td>
      <td>&nbsp;</td>
      <th>添加日期</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>40</th>
      <th> date_upd </th>
      <td>datetime </td>
      <td>否&nbsp;</td>
      <td>&nbsp;</td>
      <th>更新日期</th>
      <td>&nbsp;</td>
    </tr>
  </tbody>
</table>
<br />
<br />
<big>索引:</big>
<table>
  <tr>
    <th>键名</th>
    <th>类型</th>
    <th>基数</th>
    <th colspan="2">字段</th>
  </tr>
  <tr class="odd">
    <th  rowspan="1" > PRIMARY </th>
    <td  rowspan="1" > PRIMARY</td>
    <td  rowspan="1"  align="right"> 0&nbsp; </td>
    <td colspan="2"> id_product </td>
  </tr>
  <tr class="even">
    <th  rowspan="1" > product_supplier </th>
    <td  rowspan="1" > INDEX</td>
    <td  rowspan="1"  align="right"> 无&nbsp; </td>
    <td colspan="2"> id_supplier </td>
  </tr>
  <tr class="odd">
    <th  rowspan="1" > product_manufacturer </th>
    <td  rowspan="1" > INDEX</td>
    <td  rowspan="1"  align="right"> 无&nbsp; </td>
    <td colspan="2"> id_manufacturer </td>
  </tr>
  <tr class="even">
    <th  rowspan="1" > id_category_default </th>
    <td  rowspan="1" > INDEX</td>
    <td  rowspan="1"  align="right"> 无&nbsp; </td>
    <td colspan="2"> id_category_default </td>
  </tr>
  <tr class="odd">
    <th  rowspan="1" > id_color_default </th>
    <td  rowspan="1" > INDEX</td>
    <td  rowspan="1"  align="right"> 无&nbsp; </td>
    <td colspan="2"> id_color_default </td>
  </tr>
  <tr class="even">
    <th  rowspan="1" > date_add </th>
    <td  rowspan="1" > INDEX</td>
    <td  rowspan="1"  align="right"> 无&nbsp; </td>
    <td colspan="2"> date_add </td>
  </tr>
</table>
<hr />
<h3>product_lang 数据表</h3>
<table>
  <thead>
    <tr>
      <th>编号</th>
      <th>字段</th>
      <th>类型</th>
      <th>Null</th>
      <th>默认</th>
      <th>注释</th>
      <th>MIME</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>1</th>
      <th> id_product </th>
      <td>int(10) </td>
      <td>否&nbsp;</td>
      <td>&nbsp;</td>
      <th>商品ID</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>2</th>
      <th> id_lang </th>
      <td>int(10) </td>
      <td>否&nbsp;</td>
      <td>&nbsp;</td>
      <th>语言ID</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>3</th>
      <th> description </th>
      <td>text </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>商品介绍</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>4</th>
      <th> description_short </th>
      <td>text </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>商品简述</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>5</th>
      <th> link_rewrite </th>
      <td>varchar(128) </td>
      <td>否&nbsp;</td>
      <td>&nbsp;</td>
      <th>URL重写</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>6</th>
      <th> meta_description </th>
      <td>varchar(255) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>Meta描述</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>7</th>
      <th> meta_keywords </th>
      <td>varchar(255) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>Meta关键词</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>8</th>
      <th> meta_title </th>
      <td>varchar(128) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>Meta标题</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>9</th>
      <th> name </th>
      <td>varchar(128) </td>
      <td>否&nbsp;</td>
      <td>&nbsp;</td>
      <th>商品名称</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>10</th>
      <th> available_now </th>
      <td>varchar(255) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>有库存 时显示的字样</th>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th>11</th>
      <th> available_later </th>
      <td>varchar(255) </td>
      <td>是&nbsp;</td>
      <td><i>NULL</i>&nbsp;</td>
      <th>可订购 时显示的字样</th>
      <td>&nbsp;</td>
    </tr>
  </tbody>
</table>
<br />
<br />

<!-- Indexes --> 
<big>索引:</big>
<table>
  <tr>
    <th>键名</th>
    <th>类型</th>
    <th>基数</th>
    <th colspan="2">字段</th>
  </tr>
  <tr class="odd">
    <th  rowspan="2" > PRIMARY </th>
    <td  rowspan="2" > PRIMARY</td>
    <td  rowspan="2"  align="right"> 7&nbsp; </td>
    <td colspan="2"> id_product </td>
  </tr>
  <tr class="odd">
    <td colspan="2"> id_lang </td>
  </tr>
  <tr class="even">
    <th  rowspan="1" > id_lang </th>
    <td  rowspan="1" > INDEX</td>
    <td  rowspan="1"  align="right"> 无&nbsp; </td>
    <td colspan="2"> id_lang </td>
  </tr>
  <tr class="odd">
    <th  rowspan="1" > name </th>
    <td  rowspan="1" > INDEX</td>
    <td  rowspan="1"  align="right"> 无&nbsp; </td>
    <td colspan="2"> name </td>
  </tr>
</table>
</body>
</html>
